package com.sky.service.impl;

import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.sky.constant.MessageConstant;
import com.sky.constant.PasswordConstant;
import com.sky.constant.StatusConstant;
import com.sky.context.BaseContext;
import com.sky.dto.EmployeeDTO;
import com.sky.dto.EmployeeLoginDTO;
import com.sky.dto.EmployeePageQueryDTO;
import com.sky.entity.Employee;
import com.sky.exception.AccountLockedException;
import com.sky.exception.AccountNotFoundException;
import com.sky.exception.PasswordErrorException;
import com.sky.mapper.EmployeeMapper;
import com.sky.result.PageResult;
import com.sky.service.EmployeeService;
import net.sf.jsqlparser.statement.update.Update;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.DigestUtils;

import java.time.LocalDateTime;
import java.util.List;

@Service
public class EmployeeServiceImpl implements EmployeeService {

    @Autowired
    private EmployeeMapper employeeMapper;

    /**
     * 员工登录
     *
     * @param employeeLoginDTO
     * @return
     */
    public Employee login(EmployeeLoginDTO employeeLoginDTO) {
        String username = employeeLoginDTO.getUsername();
        String password = employeeLoginDTO.getPassword();

        //1、根据用户名查询数据库中的数据
        Employee employee = employeeMapper.getByUsername(username);

        //2、处理各种异常情况（用户名不存在、密码不对、账号被锁定）
        if (employee == null) {
            //账号不存在
            throw new AccountNotFoundException(MessageConstant.ACCOUNT_NOT_FOUND);
        }

        //密码比对
        password = DigestUtils.md5DigestAsHex(password.getBytes());

        if (!password.equals(employee.getPassword())) {
            //密码错误
            throw new PasswordErrorException(MessageConstant.PASSWORD_ERROR);
        }

        if (employee.getStatus() == StatusConstant.DISABLE) {
            //账号被锁定
            throw new AccountLockedException(MessageConstant.ACCOUNT_LOCKED);
        }

        //3、返回实体对象
        return employee;
    }

    @Override
    public void save(EmployeeDTO employeeDTO) {//这里要将EmployeeDTO转换成Employee实体，因为数据库用的是Employee而不是EmployeeDTO，况且我们还需要添加创建时间等属性

        System.out.println("当前线程的id:"+Thread.currentThread().getId());

        Employee employee = new Employee();

        //对象属性拷贝，前提是两个对象的属性名相同
        BeanUtils.copyProperties(employeeDTO, employee);

        employee.setStatus(StatusConstant.ENABLE);
        employee.setPassword(DigestUtils.md5DigestAsHex(PasswordConstant.DEFAULT_PASSWORD.getBytes()));
//        employee.setCreateTime(LocalDateTime.now());
//        employee.setUpdateTime(LocalDateTime.now());


//        employee.setCreateUser(BaseContext.getCurrentId());//因为一次请求对应一个单独的线程，我们直接放到这个线程的存储空间即可，然后从里面拿
//        employee.setUpdateUser(BaseContext.getCurrentId());//因为在拦截器中已经设置好了把当前登录人的id保存下来

        employeeMapper.insert(employee);

    }

    @Override
    public PageResult pageQuert(EmployeePageQueryDTO employeePageQueryDTO) {
        //开始分页查询(其实这个插件相当于会动态的拼接limit 页码，页记录数)
        PageHelper.startPage(employeePageQueryDTO.getPage(), employeePageQueryDTO.getPageSize());

        Page<Employee> page = employeeMapper.pageQuery(employeePageQueryDTO);//这里这个插件要求必须返回Page对象

        long total = page.getTotal();
        List<Employee> records = page.getResult();


        return new PageResult(total, records);
    }

    @Override
    public void startOrStop(Integer status, Long id) {
        //update employee set status = ? where id = ?
        //我们这里应该要动态sql，因为后续可能会修改别的东西
        Employee employee = Employee.builder().status(status).id(id).build();//没有设置的属性都是null（所以实体类的属性都使用包装类，这样能保证没有设置的就是null）
        employeeMapper.update(employee);

    }

    @Override
    public Employee getById(Long id) {
        Employee employee = employeeMapper.getById(id);
        employee.setPassword("****");//手动加密（查询不会修改数据）
        return employee;
    }

    @Override
    public void update(EmployeeDTO employeeDTO) {
        Employee employee = new Employee();
        BeanUtils.copyProperties(employeeDTO, employee);
//        employee.setUpdateTime(LocalDateTime.now());
//        employee.setUpdateUser(BaseContext.getCurrentId());
        employeeMapper.update(employee);
    }


}
